Workbook Linking

Saves the selected workbook.

Note: If a workbook has unsaved changes, it is displayed in red with an asterisk to the left of the workbook name.

Reloads an external workbook.

Reloading a workbook is important when you know that the values you have linked to your scenario have been changed and saved in the external workbook.

• Selected: Data is automatically reloaded from the external workbooks each time the scenario is opened.

Note: If you choose to automatically reload external data, and one or more workbooks cannot be located or opened, a warning appears. The scenario opens with the values that were loaded from the external workbooks the last time the scenario was saved. If you want to update the values from the external workbooks, first make sure that the workbooks exist in the expected location and that they are not in use in any other application. You can then open the Manage Links form, select the workbook, and click Reload active workbook.

• Cleared: Data is not automatically reloaded from the external workbooks.

Note: For scenarios that include external links, if you do not choose to automatically reload linked data, each time you open the scenario you are presented with options to reload the linked data or continue without reloading. Not selecting Auto reload links allows you to choose update any changed values, or continue using the existing values each time you work on the scenario.

Lists all of the sheets that exist in the workbook.

Note: For the internal workbook, to make the sheets available in the Manage Links form, select the Active check box to the left of each sheet name. Selecting the sheets enables the spreadsheet view for the data grid associated with each sheet.

A row of text control options for the cells in your worksheet. Options are:

• Text: The font type.
• Text size: The font size.
• Bold: Switches between bold and standard font.
• Italic: Switches between italic and standard font.
• Underline: Switches between underlined and standard font.
• Align text left: Aligns the text at the left of the cell.
• Centre: Aligns the text at the centre of the cell.
• Align text right: Aligns the text at the right of the cell.
• Accounting: Displays the value in the cell as a number to two decimal places, with a left aligned dollar symbol.
• Percentage: Displays the value in the cell as a percentage.
• Comma style: Displays the value in the cell with a comma after the thousands.
• Increase decimal: Increases the number of decimal places shown for the cell value.
• Decrease decimal: Decreases the number of decimal places shown for the cell value.

Note: The display value changes, but the stored value does not change.

• Number format: The format for the number in a cell. Options are; General, Short date, Long date, and Text.
• Font colour: Sets the colour of the text.
• Fill colour: Sets the colour of the cell.

Opens the Event Builder form, which you use to select a date or event to add to a cell.

If you choose a date using the Event Builder, it is added to the cell in the correct format for MineSched.

Note: If you enter dates in cells manually, it is important to use the "date dd/mm/yyyy" format. If you import a date into a scenario from an external workbook, the prefix "date" must be added to the field and the date must be formatted as text. You can format the date from an external workbook using a formula. For example, =CONCATENATE("date",TEXT([workbook_cell_reference],"dd/mm/yyyy")).

Opens the Choose a File form for you to select a file name and location to add to the currently selected cell.

The file name and the absolute folder path are added to the cell.